<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSetGDU" targetNamespace="http://tempuri.org/DataSetGDU.xsd" xmlns:mstns="http://tempuri.org/DataSetGDU.xsd" xmlns="http://tempuri.org/DataSetGDU.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="DatabaseGDUConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="DatabaseGDUConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ResaCGU.My.MySettings.GlobalReference.Default.DatabaseGDUConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserInfoTableAdapter" GeneratorDataComponentClassName="UserInfoTableAdapter" Name="UserInfo" UserDataComponentName="UserInfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseGDUConnectionString (MySettings)" DbObjectName="dbo.UserInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[UserInfo] WHERE (([UserID] = @Original_UserID) AND ((@IsNull_UserNom = 1 AND [UserNom] IS NULL) OR ([UserNom] = @Original_UserNom)) AND ((@IsNull_UserPrenom = 1 AND [UserPrenom] IS NULL) OR ([UserPrenom] = @Original_UserPrenom)) AND ((@IsNull_UserFonction = 1 AND [UserFonction] IS NULL) OR ([UserFonction] = @Original_UserFonction)) AND ((@IsNull_UserDroit = 1 AND [UserDroit] IS NULL) OR ([UserDroit] = @Original_UserDroit)) AND ((@IsNull_UserPwd = 1 AND [UserPwd] IS NULL) OR ([UserPwd] = @Original_UserPwd)) AND ((@IsNull_UserGsm = 1 AND [UserGsm] IS NULL) OR ([UserGsm] = @Original_UserGsm)) AND ((@IsNull_UserTel = 1 AND [UserTel] IS NULL) OR ([UserTel] = @Original_UserTel)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserNom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserNom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserPrenom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserPrenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserFonction" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserFonction" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserFonction" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserFonction" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserDroit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserDroit" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserDroit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserDroit" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserPwd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPwd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserPwd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPwd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserGsm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserGsm" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserGsm" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserGsm" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserTel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserTel" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserTel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserTel" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[UserInfo] ([UserID], [UserNom], [UserPrenom], [UserFonction], [UserDroit], [UserPwd], [UserGsm], [UserTel]) VALUES (@UserID, @UserNom, @UserPrenom, @UserFonction, @UserDroit, @UserPwd, @UserGsm, @UserTel);
SELECT UserID, UserNom, UserPrenom, UserFonction, UserDroit, UserPwd, UserGsm, UserTel FROM UserInfo WHERE (UserID = @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserNom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserPrenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserFonction" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserFonction" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserDroit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserDroit" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserPwd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPwd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserGsm" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserGsm" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserTel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserTel" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT UserID, UserNom, UserPrenom, UserFonction, UserDroit, UserPwd, UserGsm, UserTel FROM dbo.UserInfo</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[UserInfo] SET [UserID] = @UserID, [UserNom] = @UserNom, [UserPrenom] = @UserPrenom, [UserFonction] = @UserFonction, [UserDroit] = @UserDroit, [UserPwd] = @UserPwd, [UserGsm] = @UserGsm, [UserTel] = @UserTel WHERE (([UserID] = @Original_UserID) AND ((@IsNull_UserNom = 1 AND [UserNom] IS NULL) OR ([UserNom] = @Original_UserNom)) AND ((@IsNull_UserPrenom = 1 AND [UserPrenom] IS NULL) OR ([UserPrenom] = @Original_UserPrenom)) AND ((@IsNull_UserFonction = 1 AND [UserFonction] IS NULL) OR ([UserFonction] = @Original_UserFonction)) AND ((@IsNull_UserDroit = 1 AND [UserDroit] IS NULL) OR ([UserDroit] = @Original_UserDroit)) AND ((@IsNull_UserPwd = 1 AND [UserPwd] IS NULL) OR ([UserPwd] = @Original_UserPwd)) AND ((@IsNull_UserGsm = 1 AND [UserGsm] IS NULL) OR ([UserGsm] = @Original_UserGsm)) AND ((@IsNull_UserTel = 1 AND [UserTel] IS NULL) OR ([UserTel] = @Original_UserTel)));
SELECT UserID, UserNom, UserPrenom, UserFonction, UserDroit, UserPwd, UserGsm, UserTel FROM UserInfo WHERE (UserID = @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserNom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserPrenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserFonction" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserFonction" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserDroit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserDroit" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserPwd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPwd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserGsm" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserGsm" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserTel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserTel" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserNom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserNom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserPrenom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserPrenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserFonction" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserFonction" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserFonction" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserFonction" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserDroit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserDroit" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserDroit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserDroit" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserPwd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPwd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserPwd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPwd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserGsm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserGsm" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserGsm" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserGsm" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserTel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserTel" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserTel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserTel" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="UserNom" DataSetColumn="UserNom" />
              <Mapping SourceColumn="UserPrenom" DataSetColumn="UserPrenom" />
              <Mapping SourceColumn="UserFonction" DataSetColumn="UserFonction" />
              <Mapping SourceColumn="UserDroit" DataSetColumn="UserDroit" />
              <Mapping SourceColumn="UserPwd" DataSetColumn="UserPwd" />
              <Mapping SourceColumn="UserGsm" DataSetColumn="UserGsm" />
              <Mapping SourceColumn="UserTel" DataSetColumn="UserTel" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="DatabaseGDUConnectionString (MySettings)" DbObjectName="dbo.UserInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByUserID" GeneratorSourceName="FillByUserID" GetMethodModifier="Public" GetMethodName="GetDataByUserID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByUserID" UserSourceName="FillByUserID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     UserID, UserNom, UserPrenom, UserFonction, UserDroit, UserPwd, UserGsm, UserTel
FROM         UserInfo
WHERE     (UserID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="ID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\PASCAL\MES DOCUMENTS\VISUAL STUDIO 2005\PROJECTS\RESACGU\RESACGU\DATABASEGDU.MDF].dbo.UserInfo" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserPresenceTableAdapter" GeneratorDataComponentClassName="UserPresenceTableAdapter" Name="UserPresence" UserDataComponentName="UserPresenceTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseGDUConnectionString (MySettings)" DbObjectName="dbo.UserPresence" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[UserPresence] WHERE (([UserID] = @Original_UserID) AND ((@IsNull_UserNom = 1 AND [UserNom] IS NULL) OR ([UserNom] = @Original_UserNom)) AND ((@IsNull_UserPrenom = 1 AND [UserPrenom] IS NULL) OR ([UserPrenom] = @Original_UserPrenom)) AND ((@IsNull_UserRole = 1 AND [UserRole] IS NULL) OR ([UserRole] = @Original_UserRole)) AND ((@IsNull_UserEquipe = 1 AND [UserEquipe] IS NULL) OR ([UserEquipe] = @Original_UserEquipe)) AND ((@IsNull_UserFct = 1 AND [UserFct] IS NULL) OR ([UserFct] = @Original_UserFct)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserNom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserNom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserPrenom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserPrenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserRole" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserRole" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserRole" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserEquipe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserEquipe" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserEquipe" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserEquipe" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserFct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserFct" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UserFct" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UserFct" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[UserPresence] ([UserID], [UserNom], [UserPrenom], [UserRole], [UserEquipe], [UserFct]) VALUES (@UserID, @UserNom, @UserPrenom, @UserRole, @UserEquipe, @UserFct);
SELECT UserID, UserNom, UserPrenom, UserRole, UserEquipe, UserFct FROM UserPresence WHERE (UserID = @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserNom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserPrenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserRole" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserRole" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserEquipe" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserEquipe" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UserFct" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UserFct" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT UserID, UserNom, UserPrenom, UserRole, UserEquipe, UserFct FROM dbo.UserPresence</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[UserPresence] SET [UserID] = @UserID, [UserNom] = @UserNom, [UserPrenom] = @UserPrenom, [UserRole] = @UserRole, [UserEquipe] = @UserEquipe, [UserFct] = @UserFct WHERE (([UserID] = @Original_UserID) AND ((@IsNull_UserNom = 1 AND [UserNom] IS NULL) OR ([UserNom] = @Original_UserNom)) AND ((@IsNull_UserPrenom = 1 AND [UserPrenom] IS NULL) OR ([UserPrenom] = @Original_UserPrenom)) AND ((@IsNull_UserRole = 1 AND [UserRole] IS NULL) OR ([UserRole] = @Original_UserRole)) AND ((@IsNull_UserEquipe = 1 AND [UserEquipe] IS NULL) OR ([UserEquipe] = @Original_UserEquipe)) AND ((@IsNull_UserFct = 1 AND [UserFct] IS NULL) OR ([UserFct] = @Original_UserFct)));
SELECT UserID, UserNom, UserPrenom, UserRole, UserEquipe, UserFct FROM UserPresence WHERE (UserID = @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserNom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserPrenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserRole" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserRole" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserEquipe" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserEquipe" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UserFct" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UserFct" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserNom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserNom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserNom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserPrenom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserPrenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserPrenom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserRole" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserRole" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserRole" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserEquipe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserEquipe" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserEquipe" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserEquipe" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserFct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserFct" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_UserFct" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UserFct" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="UserNom" DataSetColumn="UserNom" />
              <Mapping SourceColumn="UserPrenom" DataSetColumn="UserPrenom" />
              <Mapping SourceColumn="UserRole" DataSetColumn="UserRole" />
              <Mapping SourceColumn="UserEquipe" DataSetColumn="UserEquipe" />
              <Mapping SourceColumn="UserFct" DataSetColumn="UserFct" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="DatabaseGDUConnectionString (MySettings)" DbObjectName="dbo.UserPresence" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserID" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByUserID" GeneratorSourceName="FillByUserID" GetMethodModifier="Public" GetMethodName="GetDataByUserID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByUserID" UserSourceName="FillByUserID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     UserID, UserNom, UserPrenom, UserRole, UserEquipe, UserFct
FROM         UserPresence
WHERE     (UserID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="ID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\PASCAL\MES DOCUMENTS\VISUAL STUDIO 2005\PROJECTS\RESACGU\RESACGU\DATABASEGDU.MDF].dbo.UserPresence" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="UserID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ListVehiculeTableAdapter" GeneratorDataComponentClassName="ListVehiculeTableAdapter" Name="ListVehicule" UserDataComponentName="ListVehiculeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseGDUConnectionString (MySettings)" DbObjectName="dbo.ListVehicule" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[ListVehicule] WHERE (([VehID] = @Original_VehID) AND ((@IsNull_VehType = 1 AND [VehType] IS NULL) OR ([VehType] = @Original_VehType)) AND ((@IsNull_VehTel = 1 AND [VehTel] IS NULL) OR ([VehTel] = @Original_VehTel)) AND ((@IsNull_VehRadio = 1 AND [VehRadio] IS NULL) OR ([VehRadio] = @Original_VehRadio)) AND ((@IsNull_VehDispo = 1 AND [VehDispo] IS NULL) OR ([VehDispo] = @Original_VehDispo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VehID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VehType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VehType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VehType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VehTel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VehTel" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VehTel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehTel" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VehRadio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VehRadio" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VehRadio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehRadio" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VehDispo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VehDispo" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VehDispo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VehDispo" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[ListVehicule] ([VehID], [VehType], [VehTel], [VehRadio], [VehDispo]) VALUES (@VehID, @VehType, @VehTel, @VehRadio, @VehDispo);
SELECT VehID, VehType, VehTel, VehRadio, VehDispo FROM ListVehicule WHERE (VehID = @VehID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VehID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VehType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VehTel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehTel" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VehRadio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehRadio" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VehDispo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VehDispo" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT VehID, VehType, VehTel, VehRadio, VehDispo FROM dbo.ListVehicule</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[ListVehicule] SET [VehID] = @VehID, [VehType] = @VehType, [VehTel] = @VehTel, [VehRadio] = @VehRadio, [VehDispo] = @VehDispo WHERE (([VehID] = @Original_VehID) AND ((@IsNull_VehType = 1 AND [VehType] IS NULL) OR ([VehType] = @Original_VehType)) AND ((@IsNull_VehTel = 1 AND [VehTel] IS NULL) OR ([VehTel] = @Original_VehTel)) AND ((@IsNull_VehRadio = 1 AND [VehRadio] IS NULL) OR ([VehRadio] = @Original_VehRadio)) AND ((@IsNull_VehDispo = 1 AND [VehDispo] IS NULL) OR ([VehDispo] = @Original_VehDispo)));
SELECT VehID, VehType, VehTel, VehRadio, VehDispo FROM ListVehicule WHERE (VehID = @VehID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VehID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VehType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VehTel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehTel" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VehRadio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehRadio" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VehDispo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VehDispo" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VehID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VehType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VehType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VehType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VehTel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VehTel" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VehTel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehTel" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VehRadio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VehRadio" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VehRadio" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VehRadio" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VehDispo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VehDispo" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VehDispo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VehDispo" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="VehID" DataSetColumn="VehID" />
              <Mapping SourceColumn="VehType" DataSetColumn="VehType" />
              <Mapping SourceColumn="VehTel" DataSetColumn="VehTel" />
              <Mapping SourceColumn="VehRadio" DataSetColumn="VehRadio" />
              <Mapping SourceColumn="VehDispo" DataSetColumn="VehDispo" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="DatabaseGDUConnectionString (MySettings)" DbObjectName="dbo.ListVehicule" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByVeHDispo" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByVeHDispo" GeneratorSourceName="FillByVeHDispo" GetMethodModifier="Public" GetMethodName="GetDataByVeHDispo" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByVeHDispo" UserSourceName="FillByVeHDispo">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     VehID, VehType, VehTel, VehRadio, VehDispo
FROM         ListVehicule
WHERE     (VehDispo = 1)</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ListeEquipeTableAdapter" GeneratorDataComponentClassName="ListeEquipeTableAdapter" Name="ListeEquipe" UserDataComponentName="ListeEquipeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseGDUConnectionString (MySettings)" DbObjectName="dbo.ListeEquipe" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[ListeEquipe] WHERE (([EquipeID] = @Original_EquipeID) AND ((@IsNull_EquipeStatut = 1 AND [EquipeStatut] IS NULL) OR ([EquipeStatut] = @Original_EquipeStatut)) AND ((@IsNull_EquipeUTMX = 1 AND [EquipeUTMX] IS NULL) OR ([EquipeUTMX] = @Original_EquipeUTMX)) AND ((@IsNull_EquipeUTMY = 1 AND [EquipeUTMY] IS NULL) OR ([EquipeUTMY] = @Original_EquipeUTMY)) AND ((@IsNull_EquipeHModif = 1 AND [EquipeHModif] IS NULL) OR ([EquipeHModif] = @Original_EquipeHModif)) AND ((@IsNull_EquipeVEH = 1 AND [EquipeVEH] IS NULL) OR ([EquipeVEH] = @Original_EquipeVEH)) AND ((@IsNull_EquipeType = 1 AND [EquipeType] IS NULL) OR ([EquipeType] = @Original_EquipeType)) AND ((@IsNull_EquipeITV = 1 AND [EquipeITV] IS NULL) OR ([EquipeITV] = @Original_EquipeITV)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EquipeID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipeStatut" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeStatut" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EquipeStatut" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeStatut" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipeUTMX" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeUTMX" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EquipeUTMX" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeUTMX" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipeUTMY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeUTMY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EquipeUTMY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeUTMY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipeHModif" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeHModif" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EquipeHModif" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EquipeHModif" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipeVEH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeVEH" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EquipeVEH" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeVEH" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipeType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EquipeType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipeITV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeITV" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EquipeITV" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeITV" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[ListeEquipe] ([EquipeID], [EquipeStatut], [EquipeUTMX], [EquipeUTMY], [EquipeHModif], [EquipeVEH], [EquipeType], [EquipeITV]) VALUES (@EquipeID, @EquipeStatut, @EquipeUTMX, @EquipeUTMY, @EquipeHModif, @EquipeVEH, @EquipeType, @EquipeITV);
SELECT EquipeID, EquipeStatut, EquipeUTMX, EquipeUTMY, EquipeHModif, EquipeVEH, EquipeType, EquipeITV FROM ListeEquipe WHERE (EquipeID = @EquipeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EquipeID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EquipeStatut" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeStatut" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EquipeUTMX" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeUTMX" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EquipeUTMY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeUTMY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EquipeHModif" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EquipeHModif" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EquipeVEH" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeVEH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EquipeType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EquipeITV" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeITV" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT EquipeID, EquipeStatut, EquipeUTMX, EquipeUTMY, EquipeHModif, EquipeVEH, EquipeType, EquipeITV FROM dbo.ListeEquipe</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[ListeEquipe] SET [EquipeID] = @EquipeID, [EquipeStatut] = @EquipeStatut, [EquipeUTMX] = @EquipeUTMX, [EquipeUTMY] = @EquipeUTMY, [EquipeHModif] = @EquipeHModif, [EquipeVEH] = @EquipeVEH, [EquipeType] = @EquipeType, [EquipeITV] = @EquipeITV WHERE (([EquipeID] = @Original_EquipeID) AND ((@IsNull_EquipeStatut = 1 AND [EquipeStatut] IS NULL) OR ([EquipeStatut] = @Original_EquipeStatut)) AND ((@IsNull_EquipeUTMX = 1 AND [EquipeUTMX] IS NULL) OR ([EquipeUTMX] = @Original_EquipeUTMX)) AND ((@IsNull_EquipeUTMY = 1 AND [EquipeUTMY] IS NULL) OR ([EquipeUTMY] = @Original_EquipeUTMY)) AND ((@IsNull_EquipeHModif = 1 AND [EquipeHModif] IS NULL) OR ([EquipeHModif] = @Original_EquipeHModif)) AND ((@IsNull_EquipeVEH = 1 AND [EquipeVEH] IS NULL) OR ([EquipeVEH] = @Original_EquipeVEH)) AND ((@IsNull_EquipeType = 1 AND [EquipeType] IS NULL) OR ([EquipeType] = @Original_EquipeType)) AND ((@IsNull_EquipeITV = 1 AND [EquipeITV] IS NULL) OR ([EquipeITV] = @Original_EquipeITV)));
SELECT EquipeID, EquipeStatut, EquipeUTMX, EquipeUTMY, EquipeHModif, EquipeVEH, EquipeType, EquipeITV FROM ListeEquipe WHERE (EquipeID = @EquipeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EquipeID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EquipeStatut" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeStatut" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EquipeUTMX" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeUTMX" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EquipeUTMY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeUTMY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EquipeHModif" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EquipeHModif" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EquipeVEH" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeVEH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EquipeType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EquipeITV" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeITV" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EquipeID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipeStatut" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeStatut" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EquipeStatut" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeStatut" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipeUTMX" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeUTMX" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EquipeUTMX" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeUTMX" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipeUTMY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeUTMY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EquipeUTMY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeUTMY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipeHModif" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeHModif" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EquipeHModif" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EquipeHModif" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipeVEH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeVEH" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EquipeVEH" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeVEH" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipeType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EquipeType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipeITV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeITV" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EquipeITV" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EquipeITV" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EquipeID" DataSetColumn="EquipeID" />
              <Mapping SourceColumn="EquipeStatut" DataSetColumn="EquipeStatut" />
              <Mapping SourceColumn="EquipeUTMX" DataSetColumn="EquipeUTMX" />
              <Mapping SourceColumn="EquipeUTMY" DataSetColumn="EquipeUTMY" />
              <Mapping SourceColumn="EquipeHModif" DataSetColumn="EquipeHModif" />
              <Mapping SourceColumn="EquipeVEH" DataSetColumn="EquipeVEH" />
              <Mapping SourceColumn="EquipeType" DataSetColumn="EquipeType" />
              <Mapping SourceColumn="EquipeITV" DataSetColumn="EquipeITV" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSetGDU" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DataSetGDU" msprop:Generator_DataSetName="DataSetGDU">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="UserInfo" msprop:Generator_UserTableName="UserInfo" msprop:Generator_RowDeletedName="UserInfoRowDeleted" msprop:Generator_RowChangedName="UserInfoRowChanged" msprop:Generator_RowClassName="UserInfoRow" msprop:Generator_RowChangingName="UserInfoRowChanging" msprop:Generator_RowEvArgName="UserInfoRowChangeEvent" msprop:Generator_RowEvHandlerName="UserInfoRowChangeEventHandler" msprop:Generator_TableClassName="UserInfoDataTable" msprop:Generator_TableVarName="tableUserInfo" msprop:Generator_RowDeletingName="UserInfoRowDeleting" msprop:Generator_TablePropName="UserInfo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserNom" msprop:Generator_UserColumnName="UserNom" msprop:Generator_ColumnPropNameInRow="UserNom" msprop:Generator_ColumnVarNameInTable="columnUserNom" msprop:Generator_ColumnPropNameInTable="UserNomColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserPrenom" msprop:Generator_UserColumnName="UserPrenom" msprop:Generator_ColumnPropNameInRow="UserPrenom" msprop:Generator_ColumnVarNameInTable="columnUserPrenom" msprop:Generator_ColumnPropNameInTable="UserPrenomColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserFonction" msprop:Generator_UserColumnName="UserFonction" msprop:Generator_ColumnPropNameInRow="UserFonction" msprop:Generator_ColumnVarNameInTable="columnUserFonction" msprop:Generator_ColumnPropNameInTable="UserFonctionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserDroit" msprop:Generator_UserColumnName="UserDroit" msprop:Generator_ColumnPropNameInRow="UserDroit" msprop:Generator_ColumnVarNameInTable="columnUserDroit" msprop:Generator_ColumnPropNameInTable="UserDroitColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserPwd" msprop:Generator_UserColumnName="UserPwd" msprop:Generator_ColumnPropNameInRow="UserPwd" msprop:Generator_ColumnVarNameInTable="columnUserPwd" msprop:Generator_ColumnPropNameInTable="UserPwdColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserGsm" msprop:Generator_UserColumnName="UserGsm" msprop:Generator_ColumnPropNameInRow="UserGsm" msprop:Generator_ColumnVarNameInTable="columnUserGsm" msprop:Generator_ColumnPropNameInTable="UserGsmColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserTel" msprop:Generator_UserColumnName="UserTel" msprop:Generator_ColumnPropNameInRow="UserTel" msprop:Generator_ColumnVarNameInTable="columnUserTel" msprop:Generator_ColumnPropNameInTable="UserTelColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UserPresence" msprop:Generator_UserTableName="UserPresence" msprop:Generator_RowDeletedName="UserPresenceRowDeleted" msprop:Generator_RowChangedName="UserPresenceRowChanged" msprop:Generator_RowClassName="UserPresenceRow" msprop:Generator_RowChangingName="UserPresenceRowChanging" msprop:Generator_RowEvArgName="UserPresenceRowChangeEvent" msprop:Generator_RowEvHandlerName="UserPresenceRowChangeEventHandler" msprop:Generator_TableClassName="UserPresenceDataTable" msprop:Generator_TableVarName="tableUserPresence" msprop:Generator_RowDeletingName="UserPresenceRowDeleting" msprop:Generator_TablePropName="UserPresence">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserNom" msprop:Generator_UserColumnName="UserNom" msprop:Generator_ColumnVarNameInTable="columnUserNom" msprop:Generator_ColumnPropNameInRow="UserNom" msprop:Generator_ColumnPropNameInTable="UserNomColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserPrenom" msprop:Generator_UserColumnName="UserPrenom" msprop:Generator_ColumnVarNameInTable="columnUserPrenom" msprop:Generator_ColumnPropNameInRow="UserPrenom" msprop:Generator_ColumnPropNameInTable="UserPrenomColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserRole" msprop:Generator_UserColumnName="UserRole" msprop:Generator_ColumnVarNameInTable="columnUserRole" msprop:Generator_ColumnPropNameInRow="UserRole" msprop:Generator_ColumnPropNameInTable="UserRoleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserEquipe" msprop:Generator_UserColumnName="UserEquipe" msprop:Generator_ColumnVarNameInTable="columnUserEquipe" msprop:Generator_ColumnPropNameInRow="UserEquipe" msprop:Generator_ColumnPropNameInTable="UserEquipeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserFct" msprop:Generator_UserColumnName="UserFct" msprop:Generator_ColumnVarNameInTable="columnUserFct" msprop:Generator_ColumnPropNameInRow="UserFct" msprop:Generator_ColumnPropNameInTable="UserFctColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ListVehicule" msprop:Generator_UserTableName="ListVehicule" msprop:Generator_RowDeletedName="ListVehiculeRowDeleted" msprop:Generator_RowChangedName="ListVehiculeRowChanged" msprop:Generator_RowClassName="ListVehiculeRow" msprop:Generator_RowChangingName="ListVehiculeRowChanging" msprop:Generator_RowEvArgName="ListVehiculeRowChangeEvent" msprop:Generator_RowEvHandlerName="ListVehiculeRowChangeEventHandler" msprop:Generator_TableClassName="ListVehiculeDataTable" msprop:Generator_TableVarName="tableListVehicule" msprop:Generator_RowDeletingName="ListVehiculeRowDeleting" msprop:Generator_TablePropName="ListVehicule">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="VehID" msprop:Generator_UserColumnName="VehID" msprop:Generator_ColumnVarNameInTable="columnVehID" msprop:Generator_ColumnPropNameInRow="VehID" msprop:Generator_ColumnPropNameInTable="VehIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehType" msprop:Generator_UserColumnName="VehType" msprop:Generator_ColumnVarNameInTable="columnVehType" msprop:Generator_ColumnPropNameInRow="VehType" msprop:Generator_ColumnPropNameInTable="VehTypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehTel" msprop:Generator_UserColumnName="VehTel" msprop:Generator_ColumnVarNameInTable="columnVehTel" msprop:Generator_ColumnPropNameInRow="VehTel" msprop:Generator_ColumnPropNameInTable="VehTelColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehRadio" msprop:Generator_UserColumnName="VehRadio" msprop:Generator_ColumnVarNameInTable="columnVehRadio" msprop:Generator_ColumnPropNameInRow="VehRadio" msprop:Generator_ColumnPropNameInTable="VehRadioColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehDispo" msprop:Generator_UserColumnName="VehDispo" msprop:Generator_ColumnVarNameInTable="columnVehDispo" msprop:Generator_ColumnPropNameInRow="VehDispo" msprop:Generator_ColumnPropNameInTable="VehDispoColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ListeEquipe" msprop:Generator_UserTableName="ListeEquipe" msprop:Generator_RowDeletedName="ListeEquipeRowDeleted" msprop:Generator_TableClassName="ListeEquipeDataTable" msprop:Generator_RowChangedName="ListeEquipeRowChanged" msprop:Generator_RowClassName="ListeEquipeRow" msprop:Generator_RowChangingName="ListeEquipeRowChanging" msprop:Generator_RowEvArgName="ListeEquipeRowChangeEvent" msprop:Generator_RowEvHandlerName="ListeEquipeRowChangeEventHandler" msprop:Generator_TablePropName="ListeEquipe" msprop:Generator_TableVarName="tableListeEquipe" msprop:Generator_RowDeletingName="ListeEquipeRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EquipeID" msprop:Generator_UserColumnName="EquipeID" msprop:Generator_ColumnPropNameInRow="EquipeID" msprop:Generator_ColumnVarNameInTable="columnEquipeID" msprop:Generator_ColumnPropNameInTable="EquipeIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EquipeStatut" msprop:Generator_UserColumnName="EquipeStatut" msprop:Generator_ColumnPropNameInRow="EquipeStatut" msprop:Generator_ColumnVarNameInTable="columnEquipeStatut" msprop:Generator_ColumnPropNameInTable="EquipeStatutColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EquipeUTMX" msprop:Generator_UserColumnName="EquipeUTMX" msprop:Generator_ColumnPropNameInRow="EquipeUTMX" msprop:Generator_ColumnVarNameInTable="columnEquipeUTMX" msprop:Generator_ColumnPropNameInTable="EquipeUTMXColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EquipeUTMY" msprop:Generator_UserColumnName="EquipeUTMY" msprop:Generator_ColumnPropNameInRow="EquipeUTMY" msprop:Generator_ColumnVarNameInTable="columnEquipeUTMY" msprop:Generator_ColumnPropNameInTable="EquipeUTMYColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EquipeHModif" msprop:Generator_UserColumnName="EquipeHModif" msprop:Generator_ColumnPropNameInRow="EquipeHModif" msprop:Generator_ColumnVarNameInTable="columnEquipeHModif" msprop:Generator_ColumnPropNameInTable="EquipeHModifColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EquipeVEH" msprop:Generator_UserColumnName="EquipeVEH" msprop:Generator_ColumnPropNameInRow="EquipeVEH" msprop:Generator_ColumnVarNameInTable="columnEquipeVEH" msprop:Generator_ColumnPropNameInTable="EquipeVEHColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EquipeType" msprop:Generator_UserColumnName="EquipeType" msprop:Generator_ColumnPropNameInRow="EquipeType" msprop:Generator_ColumnVarNameInTable="columnEquipeType" msprop:Generator_ColumnPropNameInTable="EquipeTypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EquipeITV" msprop:Generator_UserColumnName="EquipeITV" msprop:Generator_ColumnPropNameInRow="EquipeITV" msprop:Generator_ColumnVarNameInTable="columnEquipeITV" msprop:Generator_ColumnPropNameInTable="EquipeITVColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserInfo" />
      <xs:field xpath="mstns:UserID" />
    </xs:unique>
    <xs:unique name="UserPresence_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserPresence" />
      <xs:field xpath="mstns:UserID" />
    </xs:unique>
    <xs:unique name="ListVehicule_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ListVehicule" />
      <xs:field xpath="mstns:VehID" />
    </xs:unique>
    <xs:unique name="ListeEquipe_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ListeEquipe" />
      <xs:field xpath="mstns:EquipeID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_UserPresence_UserInfo" msdata:parent="UserInfo" msdata:child="UserPresence" msdata:parentkey="UserID" msdata:childkey="UserID" msprop:Generator_UserRelationName="FK_UserPresence_UserInfo" msprop:Generator_RelationVarName="relationFK_UserPresence_UserInfo" msprop:Generator_UserChildTable="UserPresence" msprop:Generator_UserParentTable="UserInfo" msprop:Generator_ParentPropName="UserInfoRow" msprop:Generator_ChildPropName="GetUserPresenceRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>